package cn.edu.niit.alienlab.jshttplessonserver.dao;

import cn.edu.niit.alienlab.jshttplessonserver.domain.MovieRatings;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MovieRatingDao {


    /*API6： 按影片id获取影片评价明细，返回评价列表*/
    @Select("SELECT mr.* FROM movie_ratings mr where mr.movie_id=#{movie_id}")
    public List<MovieRatings> selectRatingsByMovieId(Integer movie_id);

}
